Tabela PlacingReason

Definicja tabeli PlacingReason

Name

PlacingReason

Code

PlacingReason

Comment

Inf. o powodach dodania np. zlecenia leku


Lista kolumn tabeli PlacingReason

Name

Code

PlacingReasonID

PlacingReasonID

PlacingReasonTypeID

PlacingReasonTypeID

Active

Active

StartDT

StartDT

StopDT

StopDT


Kolumna PlacingReasonID tabeli PlacingReason

Definicja kolumny PlacingReasonID tabeli PlacingReason

Name

PlacingReasonID

Code

PlacingReasonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID powodu dodania


Kolumna PlacingReasonTypeID tabeli PlacingReason

Definicja kolumny PlacingReasonTypeID tabeli PlacingReason

Name

PlacingReasonTypeID

Code

PlacingReasonTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID typu powodu podania


Kolumna Active tabeli PlacingReason

Definicja kolumny Active tabeli PlacingReason

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

No

Comment

Aktywnosc rekordu


Kolumna StartDT tabeli PlacingReason

Definicja kolumny StartDT tabeli PlacingReason

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StopDT tabeli PlacingReason

Definicja kolumny StopDT tabeli PlacingReason

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli PlacingReason

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PlacingReason

Definicja klucza Identifier_1 tabeli PlacingReason

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment